<!DOCTYPE HTML>
<html lang="en">
<head>
<title>Apache Hive Language Manual - Apache Hive | Docs4dev</title>
<meta charset="UTF-8">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<meta name="description" content="The Apache Hive ™ data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage. A command line tool and JDBC driver are provided to connect users to Hive.">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="HandheldFriendly" content="true">
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta property="og:type" content="website">
<meta property="og:title" content="Apache Hive Language Manual - Apache Hive">
<meta property="og:url" content="https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/">
<meta property="og:site_name" content="Docs4dev">
<meta property="og:locale" content="zh_CN">
<meta name="twitter:card" content="The Apache Hive ™ data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage. A command line tool and JDBC driver are provided to connect users to Hive.">
<meta name="generator" content="Docs4dev template engine">
<link rel="stylesheet" href="static/css/app.min.css">
<link rel="shortcut icon" href="https://www.docs4dev.com/static/images/favicon.ico" type="image/x-icon">
<script async="" src="static/js/js.js"></script>
<script async="" src="static/js/adsbygoogle.js" crossorigin="anonymous"></script>
<script>
    window.dataLayer = window.dataLayer || [];

    function gtag() {
      dataLayer.push(arguments);
    }

    gtag('js', new Date());
    gtag('config', 'UA-129571937-1');
  </script>
<link rel="amphtml" href="https://www.docs4dev.com/amp/docs/en/apache-hive/3.1.1/reference/index.html">

<script type="application/ld+json">{"name":null,"headline":"Apache Hive Language Manual-Apache Hive","inLanguage":"en-US","version":"3.1.1","image":"/static/icon/icon-hive.png","datePublished":"2021-05-20T12:51:01Z","dateCreated":"2021-05-20T12:51:01Z","dateModified":"2021-07-05T14:25:28Z","@context":"https://schema.org/","@type":"APIReference","abstract":"The Apache Hive ™ data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage. A command line tool and JDBC driver are provided to connect users to Hive."}</script>
</head>
<body>
<div class="book with-summary">
<div class="book-summary">
<div class="logo">
<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference');" style="color: inherit;">
<img src="static/picture/icon-hive.png" style="width: 48px; height: 48px;" alt="Logo">
</a>
<b style="color: inherit; margin-left: 8px;">Apache Hive Language Manual</b>
</div>
<div class="item">
<div>
<label for="version">版本</label>
<select id="version" onchange="onVersionChange(this)">
<option value="3.1.1" selected="selected">3.1.1</option>
</select>
</div>
<div style="margin-top: 8px;">
<label for="language">语言</label>
<select id="language" onchange="onLangChange(this)" value="en">
<option value="en" selected="selected">English</option>
<option value="zh">中文</option>
</select>
</div>

</div>
<div class="item menus">
<a title="Table of Contents" style="margin-right: 8px;" href="#">
<i class="fa fa-chevron-left"></i>
<span style="margin-left: 2px;">返回目录</span>
</a>
</div>
<nav role="navigation" id="navigation">
<ul class="summary">
<li class="chapter"> <a href="" title="Commands and CLIs"> Commands and CLIs </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Commands.html');" title="Commands"> Commands </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Cli.html');" title="Hive CLI"> Hive CLI </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveServer2_Clients.html');" title="Beeline CLI"> Beeline CLI </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_VariableSubstitution.html');" title="Variable Substitution"> Variable Substitution </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HCatalog_CLI.html');" title="HCatalog CLI"> HCatalog CLI </a> </li>
</ul> </li>
<li class="chapter"> <a href="" title="File Formats "> File Formats </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/AvroSerDe.html');" title="Avro Files"> Avro Files </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_ORC.html');" title="ORC Files"> ORC Files </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Parquet.html');" title="Parquet"> Parquet </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/CompressedStorage.html');" title="Compressed Data Storage"> Compressed Data Storage </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_LZO.html');" title="LZO Compression"> LZO Compression </a> </li>
</ul> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Types.html');" title="Data Types"> Data Types </a> </li>
<li class="chapter"> <a href="" title="Data Definition Statements "> Data Definition Statements </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_DDL.html');" title="DDL Statements"> DDL Statements </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_DDL_BucketedTables.html');" title="Bucketed Tables"> Bucketed Tables </a> </li>
</ul> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/StatsDev.html');" title="Statistics (Analyze and Describe)"> Statistics (Analyze and Describe) </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Indexing.html');" title="Indexes"> Indexes </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Archiving.html');" title="Archiving"> Archiving </a> </li>
</ul> </li>
<li class="chapter"> <a href="" title="Data Manipulation Statements "> Data Manipulation Statements </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_DML.html');" title="DML: Load, Insert, Update, Delete"> DML: Load, Insert, Update, Delete </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_ImportExport.html');" title="Import/Export"> Import/Export </a> </li>
</ul> </li>
<li class="chapter"> <a href="" title="Data Retrieval: Queries"> Data Retrieval: Queries </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Select.html');" title="Select"> Select </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_GroupBy.html');" title="Group By"> Group By </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_SortBy.html');" title="Sort/Distribute/Cluster/Order By"> Sort/Distribute/Cluster/Order By </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Transform.html');" title="Transform and Map-Reduce Scripts"> Transform and Map-Reduce Scripts </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_UDF.html');" title="Operators and User-Defined Functions (UDFs)"> Operators and User-Defined Functions (UDFs) </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_XPathUDF.html');" title="XPath-specific Functions"> XPath-specific Functions </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Joins.html');" title="Joins"> Joins </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_JoinOptimization.html');" title="Join Optimization"> Join Optimization </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Union.html');" title="Union"> Union </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_LateralView.html');" title="Lateral View"> Lateral View </a> </li>
</ul> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_SubQueries.html');" title="Sub Queries"> Sub Queries </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Sampling.html');" title="Sampling"> Sampling </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_VirtualColumns.html');" title="Virtual Columns"> Virtual Columns </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_WindowingAndAnalytics.html');" title="Windowing and Analytics Functions"> Windowing and Analytics Functions </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Enhanced_Aggregation__Cube__Grouping_and_Rollup.html');" title="Enhanced Aggregation, Cube, Grouping and Rollup"> Enhanced Aggregation, Cube, Grouping and Rollup </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://cwiki.apache.org/confluence/pages/viewpage.action');" title="Hive HPL/SQL"> Hive HPL/SQL </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Explain.html');" title="Explain Execution Plan"> Explain Execution Plan </a> </li>
</ul> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Locks.html');" title="Locks"> Locks </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Authorization.html');" title="Authorization"> Authorization </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Storage_Based_Authorization_in_the_Metastore_Server.html');" title="Storage Based Authorization"> Storage Based Authorization </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/SQL_Standard_Based_Hive_Authorization.html');" title="SQL Standard Based Authorization"> SQL Standard Based Authorization </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://cwiki.apache.org/confluence/pages/viewpage.action');" title="Hive deprecated authorization mode / Legacy Mode"> Hive deprecated authorization mode / Legacy Mode </a> </li>
</ul> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Configuration_Properties.html');" title="Configuration Properties"> Configuration Properties </a> </li>
</ul>
</nav>
</div>
<div class="book-body">
<div class="body-inner">
<header class="book-header">
<div class="dropdown pull-right js-toolbar-action">
<a class="btn toggle-dropdown" aria-label="Language" href="#">
<i class="fa fa-globe"></i>
</a>
<div class="dropdown-menu dropdown-left">
<div class="dropdown-caret"><span class="caret-outer"></span><span class="caret-inner"></span></div>
<div class="buttons">
<button class="button size-1" onclick="changeLang('zh_CN')">中文</button>
</div>
<div class="buttons">
<button class="button size-1" onclick="changeLang('en_US')">English</button>
</div>
</div>
</div>
<a class="btn pull-right js-toolbar-action non-mobile" aria-label="Sign up" href="register.html">
<i class="fa fa-sign-in"></i> <span>注册</span>
</a>
<a class="btn pull-right js-toolbar-action non-mobile" aria-label="Sign in" href="register.html">
<i class="fa fa-sign-in"></i>
<span>登录</span>
</a>
<a class="btn pull-left js-toolbar-action btn-summary" href="#"><i class="fa fa-align-justify"></i></a>
<div class="dropdown pull-left font-settings js-toolbar-action">
<a class="btn toggle-dropdown" aria-label="Font Settings" href="#">
<i class="fa fa-font"></i>
</a>
<div class="dropdown-menu dropdown-right">
<div class="dropdown-caret"><span class="caret-outer"></span><span class="caret-inner"></span></div>
<div class="buttons">
<button class="button size-2 font-reduce">A</button>
<button class="button size-2 font-enlarge">A</button>
</div>
<div class="buttons">
<button class="button size-2 family-serif">Serif</button>
<button class="button size-2 family-sans">Sans</button>
</div>
<div class="buttons">
<button class="button size-3 theme-white">White</button>
<button class="button size-3 theme-sepia">Sepia</button>
<button class="button size-3 theme-night">Night</button>
</div>
</div>
</div>
<a class="btn pull-left js-toolbar-action non-mobile" aria-label="Home" href="en.html">
<i class="fa fa-home"></i> <span>首页</span>
</a>
<a class="btn pull-left js-toolbar-action non-mobile" aria-label="Guide" href="javascript:window.open('https://www.javadoc.org/');">
<i class="fa fa-book"></i> <span>API Docs</span>
</a>
<a class="btn pull-left js-toolbar-action non-mobile" aria-label="Tools" href="index37.html">
<i class="fa fa-gears"></i> <span>工具</span>
</a>
<div class="dropdown pull-left js-toolbar-action mobile">
<a class="btn toggle-dropdown" aria-label="Language" href="#">
<i class="fa fa-chevron-down"></i>
</a>
<div class="dropdown-menu dropdown-right">
<div class="dropdown-caret"><span class="caret-outer"></span><span class="caret-inner"></span></div>
<div class="buttons">
<a class="button size-1" aria-label="Home" href="en.html">
<i class="fa fa-home"></i> <span>首页</span>
</a>
</div>
<div class="buttons">
<a class="button size-1" aria-label="Guide" href="javascript:window.open('https://www.javadoc.org/');">
<i class="fa fa-book"></i> <span>API Docs</span>
</a>
</div>
<div class="buttons">
<a class="button size-1" aria-label="Tools" href="index37.html">
<i class="fa fa-gears"></i> <span>工具</span>
</a>
</div>
</div>
</div>
<div id="autocomplete" class="pull-right"></div>
<span id="toolbar-title"></span>
</header>
<div class="page-wrapper" tabindex="-1" role="main">
<div class="page-inner">
<section class="normal markdown-section">
<div id="content">
<h1>Apache Hive</h1>
<div><ins class="adsbygoogle" style="display:block; text-align:center;" data-ad-layout="in-article" data-ad-format="fluid" data-ad-client="ca-pub-6108808167664152" data-ad-slot="6964403648"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>
<div><p></p>
<div class="toc-macro client-side-toc-macro  conf-macro output-block" data-headerelements="H1,H2,H3,H4,H5,H6,H7" data-hasbody="false" data-macro-name="toc">
</div>
<p></p>
<p>The <strong><a href="javascript:window.open('https://hive.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">Apache Hive™ <i class="fa fa-external-link"></i></a></strong>&nbsp;data warehouse&nbsp;software facilitates reading, writing, and managing large datasets residing in distributed storage and queried using SQL syntax. <br><br>Built on top of <strong><a href="javascript:window.open('https://hadoop.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">Apache Hadoop™ <i class="fa fa-external-link"></i></a></strong>, Hive provides the following features:</p>
<ul>
<li>Tools to enable easy access to data via SQL, thus enabling data warehousing tasks such as extract/transform/load (ETL), reporting, and data analysis.</li>
<li>A mechanism to impose structure on a variety of data formats</li>
<li><p>Access to files stored either directly in <strong><a href="javascript:window.open('https://hadoop.apache.org/docs/current/hadoop-project-dist/hadoop-hdfs/HdfsUserGuide.html');" class="external-link" rel="noopener noreferrer" target="_blank">Apache HDFS <i class="fa fa-external-link"></i></a><strong><a href="javascript:window.open('https://hadoop.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">™ <i class="fa fa-external-link"></i></a></strong></strong>&nbsp;or in other data storage systems such as <strong><a href="javascript:window.open('https://hbase.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">Apache HBase <i class="fa fa-external-link"></i></a><strong><a href="javascript:window.open('https://hadoop.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">™ <i class="fa fa-external-link"></i></a></strong></strong>&nbsp;</p></li>
<li>Query execution via <a href="javascript:window.open('https://tez.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">Apache Tez <i class="fa fa-external-link"></i></a><strong><a href="javascript:window.open('https://hadoop.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">™ <i class="fa fa-external-link"></i></a></strong>,&nbsp;<a href="javascript:window.open('https://spark.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">Apache Spark <i class="fa fa-external-link"></i></a><strong><a href="javascript:window.open('https://hadoop.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">™ <i class="fa fa-external-link"></i></a></strong>, or&nbsp;<a href="javascript:window.open('https://hadoop.apache.org/docs/current/hadoop-mapreduce-client/hadoop-mapreduce-client-core/MapReduceTutorial.html');" class="external-link" rel="noopener noreferrer" target="_blank">MapReduce <i class="fa fa-external-link"></i></a></li>
<li>Procedural language with HPL-SQL</li>
<li>Sub-second query retrieval via <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LLAP.html');">Hive LLAP</a>, <a href="javascript:window.open('https://hadoop.apache.org/docs/r2.7.2/hadoop-yarn/hadoop-yarn-site/YARN.html');" class="external-link" rel="noopener noreferrer" target="_blank">Apache YARN <i class="fa fa-external-link"></i></a> and <a href="javascript:window.open('https://slider.incubator.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">Apache Slider <i class="fa fa-external-link"></i></a>.</li>
</ul>
<p><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Apache_Hive_SQL_Conformance.html');">Hive provides standard SQL functionality</a>, including many of the later <a href="javascript:window.open('https://en.wikipedia.org/wiki/SQL:2003');" class="external-link" rel="noopener noreferrer" target="_blank">SQL:2003 <i class="fa fa-external-link"></i></a>,&nbsp;<a href="javascript:window.open('https://en.wikipedia.org/wiki/SQL:2011');" class="external-link" rel="noopener noreferrer" target="_blank">SQL:2011 <i class="fa fa-external-link"></i></a>, and&nbsp;<a href="javascript:window.open('https://en.wikipedia.org/wiki/SQL:2016');" class="external-link" rel="noopener noreferrer" target="_blank">SQL:2016 <i class="fa fa-external-link"></i></a> features for analytics. <br>Hive's SQL can also be extended with user code via user defined functions (UDFs), user defined aggregates (UDAFs), and user defined table functions (UDTFs).</p>
<p>There is not a single "Hive format" in which data must be stored. Hive comes with built in connectors for comma and tab-separated values (CSV/TSV) text files, <a href="javascript:window.open('https://parquet.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">Apache Parquet <i class="fa fa-external-link"></i></a><strong><strong><a href="javascript:window.open('https://hadoop.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">™ <i class="fa fa-external-link"></i></a></strong></strong>,&nbsp;<a href="javascript:window.open('https://orc.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">Apache ORC <i class="fa fa-external-link"></i></a><strong><strong><a href="javascript:window.open('https://hadoop.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">™ <i class="fa fa-external-link"></i></a></strong></strong>, and other formats. Users can extend Hive with connectors for other formats. Please see <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DeveloperGuide.html#DeveloperGuide-FileFormats');">File Formats</a> and <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DeveloperGuide.html#DeveloperGuide-HiveSerDe');">Hive SerDe</a> in the <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DeveloperGuide.html');">Developer Guide</a>&nbsp;for details.</p>
<p>Hive is not designed for online transaction processing (OLTP) workloads. It is best used for traditional data warehousing tasks.</p>
<p>Hive is designed to maximize scalability (scale out with more machines added dynamically to the Hadoop cluster), performance, extensibility, fault-tolerance, and loose-coupling with its input formats.</p>
<p>Components of Hive include HCatalog and WebHCat.</p>
<ul>
<li><strong><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HCatalog.html');">HCatalog</a></strong> is a table and storage management layer for Hadoop that enables users with different data processing tools — including Pig and MapReduce — to more easily read and write data on the grid.</li>
<li><strong><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/WebHCat.html');">WebHCat</a></strong> provides a service that you can use to run Hadoop MapReduce (or YARN), Pig, Hive jobs. You can also perform Hive metadata operations using an HTTP (REST style) interface.</li>
</ul>
<h2 id="Home-HiveDocumentation"><span style="font-size: 24.0px;line-height: 1.25;">Hive Documentation</span></h2>
<p>The links below provide access to the Apache Hive wiki documents. This list is not complete, but you can navigate through these wiki pages to find additional documents.&nbsp;<span style="line-height: 1.4285715;">For more information, please see the official&nbsp;</span><a style="line-height: 1.4285715;" href="javascript:window.open('https://hive.apache.org/');" class="external-link" rel="noopener noreferrer" target="_blank">Hive website <i class="fa fa-external-link"></i></a><span style="line-height: 1.4285715;">.</span></p>
<h2 id="Home-GeneralInformationaboutHive">General Information about Hive</h2>
<ul>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/GettingStarted.html');">Getting Started</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Books_about_Hive.html');">Books about Hive</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Presentations.html');">Presentations and Papers about Hive</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/PoweredBy.html');">Sites and Applications Powered by Hive</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/RelatedProjects.html');">Related Projects</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/User_FAQ.html');">FAQ</a></li>
<li><a href="javascript:window.open('https://hive.apache.org/mailing_lists.html#Users');" class="external-link" rel="noopener noreferrer" target="_blank">Hive Users Mailing List <i class="fa fa-external-link"></i></a></li>
<li>Hive IRC Channel: <code class="notranslate">#hive</code> on irc.freenode.net</li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/AboutThisWiki.html');">About This Wiki</a></li>
</ul>
<h2 id="Home-UserDocumentation">User Documentation</h2>
<ul>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Tutorial.html');">Hive Tutorial</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual.html');">Hive SQL Language Manual</a>: &nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Commands.html');">Commands</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Cli.html');">CLIs</a>,&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Types.html');">Data Types</a>,<br>DDL (<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_DDL.html');">create/drop/alter/truncate/show/describe</a>), <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/StatsDev.html');">Statistics (analyze)</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Indexing.html');">Indexes</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Archiving.html');">Archiving</a>,<br>DML (<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_DML.html');">load/insert/update/delete/merge</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_ImportExport.html');">import/export</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Explain.html');">explain plan</a>),<br><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Select.html');">Queries (select)</a>,&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_UDF.html');">Operators and UDFs</a>,&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Locks.html');">Locks</a>,&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_Authorization.html');">Authorization</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/FileFormats.html');">File Formats and Compression</a>: &nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/RCFile.html');">RCFile</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/AvroSerDe.html');">Avro</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_ORC.html');">ORC</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Parquet.html');">Parquet</a>; <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/CompressedStorage.html');">Compression</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_LZO.html');">LZO</a></li>
<li>Procedural Language:&nbsp; <a href="javascript:window.open('https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=59690156');" target="_blank" rel="noopener noreferrer"> Hive HPL/SQL <i class="fa fa-external-link"></i></a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Configuration_Properties.html');">Hive Configuration Properties</a></li>
<li>Hive Clients
<ul>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveClient.html');">Hive Client</a> (<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveClient.html#HiveClient-JDBC');">JDBC</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveClient.html#HiveClient-ODBC');">ODBC</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveClient.html#HiveClient-ThriftJavaClient');">Thrift</a>)</li>
<li>HiveServer2: &nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveServer2_Overview.html');">Overview</a>,&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveServer2_Clients.html');">HiveServer2 Client and Beeline</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Hive_Metrics.html');">Hive Metrics</a></li>
</ul></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveWebInterface.html');">Hive Web Interface</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/SerDe.html');">Hive SerDes</a>: &nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/AvroSerDe.html');">Avro SerDe</a>,&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Parquet.html#Parquet-HiveQLSyntax');">Parquet SerDe</a>,&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/CSV_Serde.html');">CSV SerDe</a>,&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/LanguageManual_DDL.html#LanguageManualDDL-JSON');">JSON SerDe</a><span style="line-height: 1.4285715;">&nbsp;</span> <span style="line-height: 1.4285715;">&nbsp;</span></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/AccumuloIntegration.html');">Hive Accumulo Integration</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HBaseIntegration.html');">Hive HBase Integration</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Druid_Integration.html');">Druid Integration</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Kudu_Integration.html');">Kudu Integration</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Hive_Transactions.html');">Hive Transactions</a>,&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Streaming_Data_Ingest.html');">Streaming Data Ingest</a>, and&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HCatalog_Streaming_Mutation_API.html');">Streaming Mutation API</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveCounters.html');">Hive Counters</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Using_TiDB_as_the_Hive_Metastore_database.html');">Using TiDB as the Hive Metastore database</a></li>
</ul>
<h2 id="Home-AdministratorDocumentation">Administrator Documentation</h2>
<ul>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/AdminManual_Installation.html');">Installing Hive</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/AdminManual_Configuration.html');">Configuring Hive</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/AdminManual_Metastore_Administration.html');">Setting Up Metastore</a>
<ul>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Hive_Schema_Tool.html');">Hive Schema Tool</a></li>
</ul></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveWebInterface.html');">Setting Up Hive Web Interface</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/AdminManual_SettingUpHiveServer.html');">Setting Up Hive Server</a> (<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveJDBCInterface.html');">JDBC</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveODBC.html');">ODBC</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveServer.html');">Thrift</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Setting_Up_HiveServer2.html');">HiveServer2</a>)</li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Replication.html');">Hive Replication</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveAws.html');">Hive on Amazon Web Services</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveAmazonElasticMapReduce.html');">Hive on Amazon Elastic MapReduce</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Hive_on_Spark__Getting_Started.html');">Hive on Spark: Getting Started</a></li>
</ul>
<h2 id="Home-HCatalogandWebHCatDocumentation">HCatalog and WebHCat Documentation</h2>
<ul>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HCatalog.html');">HCatalog</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/WebHCat.html');">WebHCat (Templeton)</a></li>
</ul>
<h2 id="Home-ResourcesforContributors">Resources for Contributors</h2>
<ul>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HowToContribute.html');">How to Contribute</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Development_ContributorsMeetings.html');">Hive Contributors Meetings</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DeveloperDocs.html');">Hive Developer Docs</a>
<ul>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DeveloperGuide.html');">Hive Developer Guide</a>&nbsp;(<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DeveloperGuide.html#DeveloperGuide-CodeOrganizationandaBriefArchitecture');">code organization</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DeveloperGuide.html#DeveloperGuide-CompilingandRunningHive');">compile and run Hive</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DeveloperGuide.html#DeveloperGuide-Unittestsanddebugging');">unit tests</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DeveloperGuide.html#DeveloperGuide-DebuggingHiveCode');">debug</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DeveloperGuide.html#DeveloperGuide-Pluggableinterfaces');">pluggable interfaces</a>)</li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveDeveloperFAQ.html');">Hive Developer FAQ</a>&nbsp;(<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveDeveloperFAQ.html#HiveDeveloperFAQ-HowdoImovesomefiles?');">move files</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveDeveloperFAQ.html#HiveDeveloperFAQ-Building');">build Hive</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveDeveloperFAQ.html#HiveDeveloperFAQ-Testing');">test Hive</a>, <a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/MiniDriver_Tests.html');">MiniDriver and Beeline tests</a>)</li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/PluginDeveloperKit.html');">Plugin Developer Kit</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DeveloperGuide_UDTF.html');">Writing UDTFs</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Hive_APIs_Overview.html');">Hive APIs Overview</a></li>
</ul></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/TestingDocs.html');">Hive Testing Docs</a>
<ul>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HiveDeveloperFAQ.html#HiveDeveloperFAQ-Testing');">FAQ: Testing</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DeveloperGuide.html#DeveloperGuide-Unittestsanddebugging');">Developer Guide: Unit Tests</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Unit_Testing_Hive_SQL.html');">Unit Testing Hive SQL</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Unit_Test_Parallel_Execution.html');">Unit Test Parallel Execution</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/TipsForAddingNewTests.html');">Tips for Adding New Tests</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Hive_PTest2_Infrastructure.html');">Hive PTest2 Infrastructure</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Hive_PreCommit_Patch_Testing.html');">Hive PreCommit Patch Testing</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/MiniDriver_Tests.html');">MiniDriver Tests</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Running_Yetus.html');">Running Yetus</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/MetaStore_API_Tests.html');">MetaStore API Tests</a></li>
</ul></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Performance.html');">Hive Performance</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Design.html');">Hive Architecture Overview</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DesignDocs.html');">Hive Design Docs</a>: &nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DesignDocs.html#DesignDocs-Completed');">Completed</a>;&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DesignDocs.html#DesignDocs-InProgress');">In Progress</a>;&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DesignDocs.html#DesignDocs-Proposed');">Proposed</a>;&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/DesignDocs.html#DesignDocs-Incomplete');">Incomplete, Abandoned, Other</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Roadmap.html');">Roadmap/Call to Add More Features</a></li>
<li><a href="javascript:window.open('http://search-hadoop.com/Hive');" class="external-link" rel="noopener noreferrer" target="_blank">Full-Text Search over All Hive Resources <i class="fa fa-external-link"></i></a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/How_to_edit_the_website.html');">How to edit the website</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/BecomingACommitter.html');">Becoming a Committer</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HowToCommit.html');">How to Commit</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HowToRelease.html');">How to Release</a></li>
<li><a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/Bylaws.html');">Project Bylaws</a></li>
</ul>
<h2 id="Home-HiveVersionsandBranchesHiveVersionsHiveVersionsandBranches">Hive Versions and Branches<span class="confluence-anchor-link conf-macro output-inline" id="Home-HiveVersions" data-hasbody="false" data-macro-name="anchor"> </span><span class="confluence-anchor-link conf-macro output-inline" id="Home-HiveVersionsandBranches" data-hasbody="false" data-macro-name="anchor"> </span></h2>
<p><span style="letter-spacing: 0.0px;">Recent versions of Hive are available on the </span><a href="javascript:window.open('https://hive.apache.org/downloads.html');" style="letter-spacing: 0.0px;" class="external-link" rel="noopener noreferrer" target="_blank">Downloads <i class="fa fa-external-link"></i></a><span style="letter-spacing: 0.0px;"> page of the Hive website. For each version, the page provides the release date and a link to the change log. If you want a change log for an earlier version (or a development branch), use the </span><a style="letter-spacing: 0.0px;" href="javascript:window.open('https://issues.apache.org/jira/secure/ConfigureReleaseNote.jspa?projectId=12310843&amp;version=12329278');" class="external-link" rel="noopener noreferrer" target="_blank">Configure Release Notes <i class="fa fa-external-link"></i></a><span style="letter-spacing: 0.0px;"> page.</span></p>
<p>The&nbsp;<a href="javascript:window.open('https://issues.apache.org/jira/browse/HIVE');" class="external-link" rel="noopener noreferrer" target="_blank">Apache Hive JIRA <i class="fa fa-external-link"></i></a>&nbsp;keeps track of changes to Hive code, documentation, infrastructure, etc. The version number or branch for each resolved JIRA issue is shown&nbsp;in the "Fix Version/s" field&nbsp;in the Details section at the top of the issue page. For example,&nbsp;<a href="javascript:window.open('https://issues.apache.org/jira/browse/HIVE-5107');" class="external-link" rel="noopener noreferrer" target="_blank">HIVE-5107 <i class="fa fa-external-link"></i></a>&nbsp;has a fix version of 0.13.0.</p>
<p><span>Sometimes a version number changes before the release. When that happens, the original number might still be found in JIRA, wiki, and&nbsp;<a href="javascript:window.open('https://hive.apache.org/mailing_lists.html');" class="external-link" rel="noopener noreferrer" target="_blank">mailing list <i class="fa fa-external-link"></i></a>&nbsp;discussions. For example:</span></p>
<div class="table-wrap">
<table class="wrapped confluenceTable">
<colgroup>
<col>
<col>
</colgroup>
<tbody>
<tr>
<th class="confluenceTh">Release Number</th>
<th class="confluenceTh">Original Number</th>
</tr>
<tr>
<td class="confluenceTd">1.0.0</td>
<td class="confluenceTd">0.14.1</td>
</tr>
<tr>
<td class="confluenceTd">1.1.0</td>
<td class="confluenceTd">0.15.0</td>
</tr>
<tr>
<td colspan="1" class="confluenceTd">2.3.0</td>
<td colspan="1" class="confluenceTd">2.2.0</td>
</tr>
</tbody>
</table>
</div>
<p>More information about Hive branches is available in How to Contribute:&nbsp;<a href="javascript:window.open('https://www.docs4dev.com/docs/en/apache-hive/3.1.1/reference/HowToContribute.html#HowToContribute-UnderstandingHiveBranches');">Understanding Hive Branches</a>.</p>
<p><em>Apache Hive, Apache Hadoop, Apache HBase, Apache HDFS, Apache, the Apache feather logo, and the Apache Hive project logo are trademarks of The Apache Software Foundation.</em></p>
<p><br></p></div>
</div>
</section>
<div class="right-sidebar">
<div class="affix"><ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-6108808167664152" data-ad-slot="3102929424" data-ad-format="auto" data-full-width-responsive="true"></ins>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({});
</script></div>
</div>
</div>
<div class="ft">
<a href="#toolbar-title" id="anchorNavigationExGoTop"><i class="fa fa-arrow-up"></i></a>
<footer class="footer">
<div class="footer__container--normal">
<img alt="扫码关注公众号" title="扫码关注公众号" src="static/picture/qr-code.png" width="170" height="170">
<div class="footer__description--normal">
<p class="paragraph footer__author--normal">Docs4dev<sup class="super">&#xAE;</sup>
</p>
<p class="paragraph footer__quote&#45;&#45;normal">
如果你在使用过程中遇到任何问题，可以在 <a href="javascript:window.open('https://github.com/docs4dev/docs4dev-issues');" target="_blank" rel="noopener noreferrer">这里<i class="fa fa-external-link"></i></a> 提issue。
</p>
<div class="footer__main--normal">
<p class="paragraph footer__main__paragraph--normal copyright" style="color: #666 !important;">
<a href="javascript:window.open('https://beian.miit.gov.cn/');">
蜀ICP备14021783号-6
</a>
</p>
<p class="paragraph footer__main__paragraph--normal copyright" style="color: #666 !important;">
Copyright &#xA9; Docs4dev all
right reserved, powered by <a href="index2.html" target="_blank">Docs4dev</a></p>
</div>
</div>
</div>
<div class="box__issues">
</div>
</footer>
</div>
</div>
</div>
</div>
</div>
<script>
  var hasToc = true;
  /*  var downloadable = /!*false*!/ false;
    var editable = /!*false*!/ false;
    var code = /!*"apache-hive"*!/ false;
    var version = /!*"3.1.1"*!/ false;
    var type = /!*"reference"*!/ false;
    var lang = /!*"en"*!/ 'en';
    //edit link
    require(["gitbook", "jQuery"], function (gitbook, $) {
      gitbook.events.bind('start', function (e, config) {
        // Add edit toolbar to left
        var chapterId = /!*16886*!/ 0;
        if (downloadable) {
          gitbook.toolbar.createButton({
            icon: 'fa fa-download',
            text: '下载',
            onClick: function () {
              window.open('/download?code=' + code + '&version=' + version + '&type=' + type + '&lang=' + lang);
            }
          });
        }
        if (editable) {
          gitbook.toolbar.createButton({
            icon: 'fa fa-edit',
            text: '编辑此页',
            onClick: function () {
              window.open('/docs/edit?chapterId=' + chapterId + '&lang=' + lang);
            }
          });
        }
      });
    });*/
</script>
<script>
    var code = "apache-hive";
    var lang = "en";
  </script>

<script src="static/js/autocomplete-js.js"></script>
<script src="static/js/app.min.js"></script>
<script src="static/js/search.min.js"></script>
</body>
</html>
